class AddAuthorToReports < ActiveRecord::Migration
  def self.up
    add_column :reports, :author, :string
    execute("update reports r, authors a set r.author=a.name where r.author_id=a.id")
    add_index(:reports, [:author])
    drop_table(:authors)
  end

  def self.down
  end
end
